set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20;--每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20;--每天生成 20 个分区
insert overwrite table
jms_dim.dim_tab_order_source_group
select
ID
,ORDER_SOURCE_GROUP_ID
,ORDER_SOURCE_GROUP_NAME
,ORDER_SOURCE_NAME
,ORDER_SOURCE_CODE
,ORDER_SOURCE_GROUP_ID_CODE
,UPdate_BY_NAME
,UPdate_TIME
from jms_ods.tab_order_source_group
where dt = '{{ execution_date | cst_ds }}'